NTISthis.com

Evidence Guide: ICTDBS414 - Complete database backup and restore

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTDBS414 - Complete database backup and restore

What evidence can you provide to prove your understanding of each of the following citeria?

Plan database backup and restore

  1. Examine architecture of database file systems and determine likely risk and failure scenarios
  2. Determine methods for database backup and restore to mitigate likely risk and failure scenarios
  3. Prepare backup maintenance schedules according to organisational backup and restore policy
  4. Prepare contingency plans according to organisational backup and restore policy
Examine architecture of database file systems and determine likely risk and failure scenarios

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine methods for database backup and restore to mitigate likely risk and failure scenarios

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Prepare backup maintenance schedules according to organisational backup and restore policy

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Prepare contingency plans according to organisational backup and restore policy

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Undertake backup methods appropriate to database requirements

  1. Complete full off-line backups with acceptable downtime according to organisational backup and restore policy and procedure
  2. Complete online file backups with acceptable downtime according to organisational backup and restore policy and procedure and organisational data security plan
  3. Deploy redundant array of inexpensive disks (RAID) configuration aligned with the organisational backup and restore policy
  4. Arrange off-site copies of backup files consistent with organisational back and restore procedure and organisational data protection plan
Complete full off-line backups with acceptable downtime according to organisational backup and restore policy and procedure

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Complete online file backups with acceptable downtime according to organisational backup and restore policy and procedure and organisational data security plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Deploy redundant array of inexpensive disks (RAID) configuration aligned with the organisational backup and restore policy

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Arrange off-site copies of backup files consistent with organisational back and restore procedure and organisational data protection plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Establish and test recovery points and disaster-recovery procedures

  1. Determine and document database recovery points based on backup methods, according to organisational backup and restore policy and procedure
  2. Test restore process to ensure database can be restored to given recovery points with acceptable down time as specified in organisational backup and restore policy
  3. Complete and document restoration of databases to point of failure, without loss of committed transactions
Determine and document database recovery points based on backup methods, according to organisational backup and restore policy and procedure

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test restore process to ensure database can be restored to given recovery points with acceptable down time as specified in organisational backup and restore policy

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Complete and document restoration of databases to point of failure, without loss of committed transactions

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create and deploy a standby database

  1. Create and deploy standby databases to support critical organisational functions according to organisational back and restore policy and procedure
  2. Prepare documentation for standby databases that meet requirements of organisational backup and restore policy
Create and deploy standby databases to support critical organisational functions according to organisational back and restore policy and procedure

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Prepare documentation for standby databases that meet requirements of organisational backup and restore policy

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Required Skills and Knowledge